<?php

namespace app\common\model;

use think\Db;
use think\Model;

/**
 * 员工考核
 * @author lcx
 * @date 2019-03-18
 */
class OaWorkersExamModel extends Model {

  // 表名
  protected $name = 'oa_workers_exam';

  // 列表查询
  public function getAll($where, $join=[], $page=1, $pageSize=10, $field='*', $order='start_time desc') {
    if ($pageSize > 0) {
      $result = $this->alias('a')
                    ->where($where)
                    ->join($join)
                    ->field($field)
                    ->page($page, $pageSize)
                    ->order($order)
                    ->select();
    } else {
      $result = $this->alias('a')
                  ->where($where)
                  ->join($join)
                  ->field($field)
                  ->order($order)
                  ->select();
    }

    return $result;
  }

  // 数量查询
  public function getCount($where, $join=[]) {
    $result = $this->where($where)
            ->join($join)
            ->count();
    return $result;
  }

  // 单个查询
  public function getOne($where, $join, $field) {
    $result = $this->alias('ce')->where($where)
            ->join($join)
            ->field($field)
            ->find();
    return $result;
  }

  // 添加操作
  public function add($data) {
    $result = $this->insertGetId($data);
    return $result;
  }

  // 编辑操作
  public function edit($where, $data) {
    $result = $this->where($where)->update($data);
    return $result;
  }

}
